package com.example.xiaomi.mapper;

import com.example.xiaomi.entity.topic;
import com.example.xiaomi.entity.userinfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
@Mapper
public interface UserMapper {
    @Select("SELECT * FROM film WHERE age !=0  LIMIT 30; \n")
    List<userinfo> findAllUser();
    @Select("SELECT * FROM film WHERE mid = #{mid}\n")
    userinfo findUserBYID(Integer mid);

}




